package com.zb.dao.impl;

import com.zb.dao.OrderDao;
import com.zb.pojo.Order;

import java.util.List;

/**
 * @author zb
 * @create 2021-03-09 10:14
 */
public class OrderDaoImpl extends BaseDao implements OrderDao {
    @Override
    public int saveOrder(Order order) {

        System.out.println("OrderDaoImpl程序在【"+Thread.currentThread()+"】");

        String sql = "insert into t_order(order_id,create_time,price,status,user_id) values(?,?,?,?,?)";
        return update(sql,order.getOrderId(),order.getCreateTime(),order.getPrice(),order.getStatus(),order.getUserId());
    }

    @Override
    public List<Order> queryOrders() {
        String sql = "select order_id orderId,create_time createTime,price,status,user_id userId from t_order";
        return queryForList(Order.class,sql);
    }

    @Override
    public boolean changeOrderStatus(String orderId,Integer status) {
        String sql = "update t_order set status=? where order_id=?";
        return update(sql,status,orderId)>0;
    }

    @Override
    public List<Order> queryOrdersByUserId(Integer userId) {
        String sql = "select order_id orderId,create_time createTime,price,status,user_id userId from t_order where user_id=?";
        return queryForList(Order.class,sql,userId);
    }
}
